from elixir import *
# elixir ORM stuff
metadata.bind ='sqlite:///Polytrauma_Tracking.sqlite3'
metadata.bind.echo = True

class SLA(Entity):
    id = Field(Integer, primary_key = True)
    patient_id = Field(Integer)
    assessment = Field(Text)
    last_extraction_date = Field(DateTime)

    using_options(tablename = 'PITS_second_level_assessment')

    def __repr__ (self):
        return '<Level2 "patient: %d">' %(self.patient)
